We have an MS/Access database that works fine in Office 2007 but in Office 2010, the user cannot update it. She receives the msg "The recordset is not updateable".
I tried it on Windows 7 and Windows/XP with Office 2010 but get the same result. I have reviewed possible causes of this msg. The tables have primary keys and have not changed. I ensured that the application is trusted and is in a trusted location. It does run macros and I suspect it has something to do with that. I also tried changing the sandbox mode to permit it to run anything...same result. I want to stress that the db is exactly the same on both Access 2007 and Access 2010. Has anyone else run into a similar problem?